Extending the Multidimensional Model for Linking Cubes

نویسندگان

  • Alberto Sabaini
  • Esteban Zimányi
  • Carlo Combi
چکیده

Data warehouses structure data in multidimensional cubes, where dimensions specify different ways in which measures in facts may be viewed, aggregated, and sorted. It is essential for data analysts to combine data from heterogeneous multidimensional cubes to enhance their analysis capabilities. For this, users are restricted in using only shared dimensions for navigating related multidimensional cubes. In this paper, we show that this limits the analysis possibilities and introduce an explicit link that relates two multidimensional cubes, indicating that they represent different aspects of the same reality, and hence they may be connected. We argue that the standard drill-across operator is not suited to perform such operation, and we extend it by proposing a new operator called drill-across-link.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

An Object Oriented Multidimensional Data Model for OLAP

Online Analytical Processing (OLAP) data is frequently organized in the form of multidimensional data cubes each of which is used to examine a set of data values, called measures, associated with multiple dimensions and their multiple levels. In this paper, we first propose a conceptual multidimensional data model, which is able to represent and capture natural hierarchical relationships among ...

متن کامل

Drill Across and Visualization of Cubes with Non-conformed Dimensions

Data analysts would benefit greatly from the ability to navigate and view combined multidimensional data from multiple sources, a key requirement of which is the conformity between their dimensions. The strict requirements of conformity restrict navigating to related multidimensional data from unseen or unfamiliar sources. In this paper we make a distinction between conformed dimension tables a...

متن کامل

Drill Across & Visualization of Cubes with Non-Conformed Dimensions

Data analysts would benefit greatly from the ability to navigate and view combined multidimensional data from multiple sources, a key requirement of which is the conformity between their dimensions. The strict requirements of conformity restrict navigating to related multidimensional data from unseen or unfamiliar sources. In this paper we make a distinction between conformed dimension tables a...

متن کامل

Sparsity Handling and Data Explosion in OLAP Systems

A common problem with OnLine Analytical Processing (OLAP) databases is data explosion data size multiplies, when it is loaded from the source data into multidimensional cubes. Data explosion is not an issue for small databases, but can be serious problems with large databases. In this paper we discuss the sparsity and data explosion phenomenon in multidimensional data model, which lie at the co...

متن کامل

Modeling Multidimensional Databases, Cubes and Cube Operations

On-Line Analytical Processing (OLAP) is a trend in database technology, which was recently introduced and has attracted the interest of a lot of research work. OLAP is based on the multidimensional view of data, supported either by multidimensional databases (MOLAP) or relational engines (ROLAP). In this paper we propose a model for multidimensional databases. Dimensions, dimension hierarchies ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2015